package com.koron.css2.serviceManage.mapper;

import com.koron.css2.serviceManage.bean.DbServerBean;
import com.koron.css2.serviceManage.dto.DataSourceConfigDTO;
import com.koron.css2.serviceManage.vo.ComboBoxVO;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface DbServerMapper {

	public List<DbServerBean> find(DbServerBean bean);

	public DbServerBean selectById(@Param("dbId") String dbId);

	public Integer save(DbServerBean bean);

	public Integer update(DbServerBean bean);

	public List<ComboBoxVO> selectComboBox();
	
	public List<DataSourceConfigDTO> selectDataSource(String waterCodeFilter);
	
	public DataSourceConfigDTO selectDataSourceByCompanyNo(@Param("companyNo") String companyNo,@Param("waterCodeFilter") String waterCodeFilter);
	
	/**
	 * 获取水司编号
	 * @return
	 * @param waterCodeFilter
	 */
	public List<String>  selectCompany(String waterCodeFilter);
	
	/**
	 * 获取水司编号和数据库名
	 */
	@SuppressWarnings("rawtypes")
	public List<Map> selectCompanyAndDb(String waterCodeFilter);
}
